Inter- and Intra-Transaction Parallelism in Database Systems
نویسندگان
چکیده
This paper presents an approach to improving database performance by combining parallelism of multiple independent transactions and parallelism of multiple sub-transactions within a transaction. An experimental prototype has been built that supports this combination of inter-and intra-transaction parallelism based on the framework of multi-level transaction management. A performance study for a foreign exchange banking application has been carried out to obtain insights into the interaction of inter-and intra-transaction parallelism. Signiicant performance improvements could be gained when both update and retrieval transactions were par-allelized.
منابع مشابه
A hybrid approach for database intrusion detection at transaction and inter-transaction levels
Nowadays, information plays an important role in organizations. Sensitive information is often stored in databases. Traditional mechanisms such as encryption, access control, and authentication cannot provide a high level of confidence. Therefore, the existence of Intrusion Detection Systems in databases is necessary. In this paper, we propose an intrusion detection system for detecting attacks...
متن کاملAnalysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems
Parallel database systems have to support both inter-transaction as well as intra-transaction parallelism. Inter-transaction parallelism (multi-user mode) is required to achieve high throughput, in particular for OLTP transactions, and sufficient cost-effectiveness. Intra-transaction parallelism is a prerequisite for reducing the response time of complex and data-intensive transactions (queries...
متن کاملDynamic Load Balancing in Parallel Database Systems
Parallel database systems have to support both inter-transaction as well as intra-transaction parallelism. Inter-transaction parallelism (multi-user mode) is required to achieve high throughput, in particular for OLTP transactions, and sufficient cost-effectiveness. Intratransaction parallelism is a prerequisite for reducing the response time of complex and dataintensive transactions (queries)....
متن کاملBuilding Middleware for Higher-Order Object Data Management
Future object managers will utilise existing relational database systems as primitive building blocks replacing today's le systems. SQL, similar to assembler language today, will be used to implement higher-order object managers. Current middleware layers will be extended to a coordination layer that uses and controls di erent database systems used as storage systems and as index managers. We s...
متن کاملCompile-time inter-query dependence analysis
Most parallel databases exploit two types of parallelism: intra-query parallelism and inter-transaction concurrency. Between these two cases lies another type of parallelism: inter-query parallelism within a transaction or application. Exploiting inter-query parallelism requires either compiler support to automatically parallelize the existing embedded query programs, or programming support to ...
متن کامل